mysql > grant replication slave on *.* to webadmin@'172.17.22.51.%' identified by 'def_passwd'; mysql > show master status\G
从服务器上配置连接主服务器 (重启mysql,不需要每次都执行一次,仅执行一次即可)
1 2 3 4 5 6 7 8 9 10 11 12 13
# mysql -uroot -p Enter password: mysql > stop slave; mysql >change master to master_host='172.17.22.50', master_port=3306, master_user='webadmin', master_password='def_passwd', master_log_file='mysql1-bin.000008', master_log_pos=454; mysql > start slave; mysql > show slave status\G
验证
主服务器上创建数据库、表、并插入数据
1 2 3 4 5 6 7 8 9 10
mysql > CREATE DATABASE test_ab default charset utf8; mysql > CREATE TABLE test_ab.a1(id int(2),name varchar(20)); mysql > INSERT INTO test_ab.a1(id,name) VALUES(1,"测试1"); mysql> select * from test_ab.a1; +------+---------+ | id | name | +------+---------+ | 1 | 测试1 | +------+---------+ 1 row in set (0.00 sec)
从服务器上查询该数据,验证是否复制过来
1 2 3 4 5 6 7
mysql> select * from test; +------+---------+ | id | name | +------+---------+ | 1 | 测试1 | +------+---------+ 1 row in set (0.00 sec)